combined_tripdata.csv

Dataset statistics

Number of variables	14
Number of observations	2506983
Missing cells	569378
Missing cells (%)	1.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 GiB
Average record size in memory	512.4 B

Variable types

NUM	8
CAT	5
BOOL	1

Reproduction

Analysis started	2020-07-12 17:17:33.546041
Analysis finished	2020-07-12 17:20:35.299374
Duration	3 minutes and 1.75 second
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`start_time` has a high cardinality: 2502118 distinct values	High cardinality
`end_time` has a high cardinality: 2502116 distinct values	High cardinality
`start_station_name` has a high cardinality: 446 distinct values	High cardinality
`end_station_name` has a high cardinality: 446 distinct values	High cardinality
`end_station_longitude` is highly correlated with `end_station_latitude`	High correlation
`end_station_latitude` is highly correlated with `end_station_longitude`	High correlation
`start_station_id` has 80734 (3.2%) missing values	Missing
`start_station_name` has 80133 (3.2%) missing values	Missing
`end_station_id` has 82902 (3.3%) missing values	Missing
`end_station_name` has 82350 (3.3%) missing values	Missing
`bike_share_for_all_trip` has 243259 (9.7%) missing values	Missing
`duration_sec` is highly skewed (γ1 = 61.41479711)	Skewed
`start_station_latitude` is highly skewed (γ1 = -103.0494041)	Skewed
`start_station_longitude` is highly skewed (γ1 = 309.5870215)	Skewed
`end_station_latitude` is highly skewed (γ1 = -125.689168)	Skewed
`end_station_longitude` is highly skewed (γ1 = 165.6630369)	Skewed
`start_time` is uniformly distributed	Uniform
`end_time` is uniformly distributed	Uniform

duration_sec
Real number (ℝ_≥0)

SKEWED

Distinct count	15280
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	807.6483298849653
Minimum	60
Maximum	912110
Zeros	0
Zeros (%)	0.0%
Memory size	19.1 MiB

Quantile statistics

Minimum	60
5-th percentile	182
Q1	359
median	571
Q3	887
95-th percentile	1760
Maximum	912110
Range	912050
Interquartile range (IQR)	528

Descriptive statistics

Standard deviation	1974.713981
Coefficient of variation (CV)	2.445017104
Kurtosis	18790.78908
Mean	807.6483299
Median Absolute Deviation (MAD)	246
Skewness	61.41479711
Sum	2024760633
Variance	3899495.305

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
339	3298	0.1%
370	3268	0.1%
372	3251	0.1%
353	3244	0.1%
355	3242	0.1%
383	3236	0.1%
390	3233	0.1%
324	3231	0.1%
375	3221	0.1%
340	3218	0.1%
380	3214	0.1%
384	3214	0.1%
364	3213	0.1%
358	3213	0.1%
313	3212	0.1%
349	3212	0.1%
387	3208	0.1%
327	3206	0.1%
395	3206	0.1%
359	3205	0.1%
386	3204	0.1%
396	3203	0.1%
381	3202	0.1%
347	3201	0.1%
346	3199	0.1%
Other values (15255)	2426429	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
60	38	< 0.1%
61	298	< 0.1%
62	291	< 0.1%
63	307	< 0.1%
64	288	< 0.1%
65	300	< 0.1%
66	324	< 0.1%
67	317	< 0.1%
68	318	< 0.1%
69	341	< 0.1%

Value	Count	Frequency (%)
912110	1	< 0.1%
86230	1	< 0.1%
86217	1	< 0.1%
86114	2	< 0.1%
85952	1	< 0.1%
85935	1	< 0.1%
85904	1	< 0.1%
85702	1	< 0.1%
85676	1	< 0.1%
85545	1	< 0.1%

start_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	2502118
Unique (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	19.1 MiB

2019-07-30 07:59:17	5
2019-07-31 08:25:09	4
2019-07-27 18:57:16	4
2019-07-24 08:46:17	4
2019-07-25 07:51:36	4
Other values (2502113)	2506962

Value	Count	Frequency (%)
2019-07-30 07:59:17	5	< 0.1%
2019-07-31 08:25:09	4	< 0.1%
2019-07-27 18:57:16	4	< 0.1%
2019-07-24 08:46:17	4	< 0.1%
2019-07-25 07:51:36	4	< 0.1%
2019-07-24 08:57:12	4	< 0.1%
2019-07-27 17:23:45	4	< 0.1%
2019-07-23 08:31:17	4	< 0.1%
2019-07-24 07:58:16	3	< 0.1%
2019-07-22 17:27:10	3	< 0.1%
2019-07-30 12:19:03	3	< 0.1%
2019-07-29 08:39:02	3	< 0.1%
2019-07-27 12:23:02	3	< 0.1%
2019-07-21 15:39:48	3	< 0.1%
2019-07-23 17:04:53	3	< 0.1%
2019-07-22 12:51:23	3	< 0.1%
2019-07-27 15:41:20	3	< 0.1%
2019-07-26 17:51:04	3	< 0.1%
2019-07-23 17:16:24	3	< 0.1%
2019-07-25 12:15:39	3	< 0.1%
2019-07-24 09:23:32	3	< 0.1%
2019-07-27 15:40:15	3	< 0.1%
2019-07-28 16:18:45	3	< 0.1%
2019-07-25 08:24:20	3	< 0.1%
2019-07-24 09:11:09	3	< 0.1%
Other values (2502093)	2506899	> 99.9%

Length

Max length	24
Median length	24
Mean length	23.75899717
Min length	19

Overview of Unicode Properties

Unique unicode characters	14
Unique unicode categories (?)	4
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	11032963	18.5%
1	8383773	14.1%
2	6351336	10.7%
-	5013966	8.4%
:	5013966	8.4%
9	4548090	7.6%
3	2819146	4.7%
4	2658182	4.5%
5	2613318	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2188453	3.7%
7	2153782	3.6%
6	1893299	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	44642342	74.9%
Other Punctuation	7400111	12.4%
Dash Punctuation	5013966	8.4%
Space Separator	2506983	4.2%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	11032963	24.7%
1	8383773	18.8%
2	6351336	14.2%
9	4548090	10.2%
3	2819146	6.3%
4	2658182	6.0%
5	2613318	5.9%
8	2188453	4.9%
7	2153782	4.8%
6	1893299	4.2%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	5013966	100.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	2506983	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
:	5013966	67.8%
.	2386145	32.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	59563402	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	11032963	18.5%
1	8383773	14.1%
2	6351336	10.7%
-	5013966	8.4%
:	5013966	8.4%
9	4548090	7.6%
3	2819146	4.7%
4	2658182	4.5%
5	2613318	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2188453	3.7%
7	2153782	3.6%
6	1893299	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59563402	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	11032963	18.5%
1	8383773	14.1%
2	6351336	10.7%
-	5013966	8.4%
:	5013966	8.4%
9	4548090	7.6%
3	2819146	4.7%
4	2658182	4.5%
5	2613318	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2188453	3.7%
7	2153782	3.6%
6	1893299	3.2%

end_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	2502116
Unique (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	19.1 MiB

2019-07-22 08:35:41	4
2019-07-25 10:30:53	4
2019-07-27 18:08:44	4
2019-07-26 10:04:08	4
2019-07-25 08:17:40	4
Other values (2502111)	2506963

Value	Count	Frequency (%)
2019-07-22 08:35:41	4	< 0.1%
2019-07-25 10:30:53	4	< 0.1%
2019-07-27 18:08:44	4	< 0.1%
2019-07-26 10:04:08	4	< 0.1%
2019-07-25 08:17:40	4	< 0.1%
2019-07-26 18:19:52	3	< 0.1%
2019-07-30 17:20:54	3	< 0.1%
2019-07-28 15:50:47	3	< 0.1%
2019-07-29 08:38:39	3	< 0.1%
2019-07-26 13:53:14	3	< 0.1%
2019-07-25 17:26:23	3	< 0.1%
2019-07-24 07:54:38	3	< 0.1%
2019-07-31 07:54:41	3	< 0.1%
2019-07-26 17:25:13	3	< 0.1%
2019-07-24 11:52:18	3	< 0.1%
2019-07-22 12:27:28	3	< 0.1%
2019-07-20 13:20:18	3	< 0.1%
2019-07-22 19:14:24	3	< 0.1%
2019-07-31 08:56:48	3	< 0.1%
2019-07-23 17:28:31	3	< 0.1%
2019-07-19 09:32:09	3	< 0.1%
2019-07-23 06:52:38	3	< 0.1%
2019-07-31 08:51:24	3	< 0.1%
2019-07-20 17:26:41	3	< 0.1%
2019-07-26 18:44:37	3	< 0.1%
Other values (2502091)	2506903	> 99.9%

Length

Max length	24
Median length	24
Mean length	23.75899717
Min length	19

Overview of Unicode Properties

Unique unicode characters	14
Unique unicode categories (?)	4
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	11014233	18.5%
1	8377903	14.1%
2	6406658	10.8%
-	5013966	8.4%
:	5013966	8.4%
9	4587894	7.7%
3	2816163	4.7%
4	2636400	4.4%
5	2624607	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2190284	3.7%
7	2118315	3.6%
6	1869885	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	44642342	74.9%
Other Punctuation	7400111	12.4%
Dash Punctuation	5013966	8.4%
Space Separator	2506983	4.2%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	11014233	24.7%
1	8377903	18.8%
2	6406658	14.4%
9	4587894	10.3%
3	2816163	6.3%
4	2636400	5.9%
5	2624607	5.9%
8	2190284	4.9%
7	2118315	4.7%
6	1869885	4.2%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	5013966	100.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	2506983	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
:	5013966	67.8%
.	2386145	32.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	59563402	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	11014233	18.5%
1	8377903	14.1%
2	6406658	10.8%
-	5013966	8.4%
:	5013966	8.4%
9	4587894	7.7%
3	2816163	4.7%
4	2636400	4.4%
5	2624607	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2190284	3.7%
7	2118315	3.6%
6	1869885	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	59563402	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	11014233	18.5%
1	8377903	14.1%
2	6406658	10.8%
-	5013966	8.4%
:	5013966	8.4%
9	4587894	7.7%
3	2816163	4.7%
4	2636400	4.4%
5	2624607	4.4%
	2506983	4.2%
.	2386145	4.0%
8	2190284	3.7%
7	2118315	3.6%
6	1869885	3.1%

start_station_id
Real number (ℝ_≥0)

MISSING

Distinct count	436
Unique (%)	< 0.1%
Missing	80734
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%

Mean	146.50474910036027
Minimum	3.0
Maximum	498.0
Zeros	0
Zeros (%)	0.0%
Memory size	19.1 MiB

Quantile statistics

Minimum	3
5-th percentile	8
Q1	47
median	105
Q3	243
95-th percentile	376
Maximum	498
Range	495
Interquartile range (IQR)	196

Descriptive statistics

Standard deviation	122.3171024
Coefficient of variation (CV)	0.8349019614
Kurtosis	-0.5575613587
Mean	146.5047491
Median Absolute Deviation (MAD)	79
Skewness	0.7718204869
Sum	355457001
Variance	14961.47353

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
58	45058	1.8%
81	42962	1.7%
30	40302	1.6%
15	39016	1.6%
67	36576	1.5%
21	36081	1.4%
3	34253	1.4%
16	32448	1.3%
22	31341	1.3%
5	30581	1.2%
6	28785	1.1%
50	24424	1.0%
66	23093	0.9%
17	22094	0.9%
93	21437	0.9%
90	21116	0.8%
27	20818	0.8%
44	20551	0.8%
104	20015	0.8%
23	19219	0.8%
61	18335	0.7%
243	17302	0.7%
19	17158	0.7%
114	17100	0.7%
350	16127	0.6%
Other values (411)	1750057	69.8%
(Missing)	80734	3.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	34253	1.4%
4	7115	0.3%
5	30581	1.2%
6	28785	1.1%
7	10068	0.4%
8	10514	0.4%
9	10584	0.4%
10	9533	0.4%
11	11752	0.5%
12	3379	0.1%

Value	Count	Frequency (%)
498	11	< 0.1%
495	22	< 0.1%
494	20	< 0.1%
493	388	< 0.1%
492	69	< 0.1%
491	39	< 0.1%
490	42	< 0.1%
489	46	< 0.1%
488	16	< 0.1%
487	391	< 0.1%

start_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	446
Unique (%)	< 0.1%
Missing	80133
Missing (%)	3.2%
Memory size	19.1 MiB

Market St at 10th St	45058
Berry St at 4th St	42962
San Francisco Caltrain (Townsend St at 4th St)	40302
San Francisco Ferry Building (Harry Bridges Plaza)	39016
San Francisco Caltrain Station 2 (Townsend St at 4th St)	36576
Other values (441)	2222936

Value	Count	Frequency (%)
Market St at 10th St	45058	1.8%
Berry St at 4th St	42962	1.7%
San Francisco Caltrain (Townsend St at 4th St)	40302	1.6%
San Francisco Ferry Building (Harry Bridges Plaza)	39016	1.6%
San Francisco Caltrain Station 2 (Townsend St at 4th St)	36576	1.5%
Montgomery St BART Station (Market St at 2nd St)	36081	1.4%
Powell St BART Station (Market St at 4th St)	34253	1.4%
Steuart St at Market St	32448	1.3%
Howard St at Beale St	31341	1.3%
Powell St BART Station (Market St at 5th St)	30581	1.2%
The Embarcadero at Sansome St	28785	1.1%
2nd St at Townsend St	24424	1.0%
3rd St at Townsend St	23093	0.9%
Embarcadero BART Station (Beale St at Market St)	22094	0.9%
4th St at Mission Bay Blvd S	21437	0.9%
Townsend St at 7th St	21116	0.8%
Beale St at Harrison St	20818	0.8%
Civic Center/UN Plaza BART Station (Market St at McAllister St)	20551	0.8%
4th St at 16th St	20015	0.8%
The Embarcadero at Steuart St	19219	0.8%
Howard St at 8th St	18335	0.7%
Bancroft Way at College Ave	17302	0.7%
Post St at Kearny St	17158	0.7%
Rhode Island St at 17th St	17100	0.7%
8th St at Brannan St	16127	0.6%
Other values (421)	1750658	69.8%
(Missing)	80133	3.2%

Length

Max length	63
Median length	22
Mean length	25.51926439
Min length	3

Overview of Unicode Properties

Unique unicode characters	67
Unique unicode categories (?)	8
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	10770968	16.8%
t	8778342	13.7%
a	6073454	9.5%
S	4429118	6.9%
e	3371135	5.3%
r	3134014	4.9%
n	3036622	4.7%
o	2540444	4.0%
i	1855330	2.9%
l	1749711	2.7%
s	1493751	2.3%
h	1391593	2.2%
d	1154115	1.8%
c	884280	1.4%
B	859934	1.3%
A	796863	1.2%
y	723039	1.1%
k	674159	1.1%
v	630303	1.0%
T	620742	1.0%
M	614401	1.0%
P	543646	0.8%
F	453604	0.7%
m	447275	0.7%
w	438080	0.7%
Other values (42)	6511439	10.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	39929718	62.4%
Space Separator	10770968	16.8%
Uppercase Letter	10643290	16.6%
Decimal Number	1855661	2.9%
Open Punctuation	366393	0.6%
Close Punctuation	366393	0.6%
Other Punctuation	43882	0.1%
Dash Punctuation	57	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
S	4429118	41.6%
B	859934	8.1%
A	796863	7.5%
T	620742	5.8%
M	614401	5.8%
P	543646	5.1%
F	453604	4.3%
C	416586	3.9%
R	323208	3.0%
H	315983	3.0%
E	179890	1.7%
D	151517	1.4%
V	147822	1.4%
G	140555	1.3%
W	137097	1.3%
N	93299	0.9%
J	90325	0.8%
K	86915	0.8%
L	80583	0.8%
U	59771	0.6%
O	58020	0.5%
I	31344	0.3%
Y	12003	0.1%
Q	64	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
t	8778342	22.0%
a	6073454	15.2%
e	3371135	8.4%
r	3134014	7.8%
n	3036622	7.6%
o	2540444	6.4%
i	1855330	4.6%
l	1749711	4.4%
s	1493751	3.7%
h	1391593	3.5%
d	1154115	2.9%
c	884280	2.2%
y	723039	1.8%
k	674159	1.7%
v	630303	1.6%
m	447275	1.1%
w	438080	1.1%
u	435219	1.1%
g	397605	1.0%
b	289580	0.7%
p	150161	0.4%
z	122528	0.3%
f	104025	0.3%
q	37924	0.1%
j	10514	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	10770968	100.0%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	366393	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	416820	22.5%
2	357586	19.3%
4	303569	16.4%
5	175113	9.4%
7	136498	7.4%
3	115028	6.2%
0	106214	5.7%
9	88065	4.7%
6	78822	4.2%
8	77946	4.2%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	366393	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	23930	54.5%
'	13283	30.3%
&	6669	15.2%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	57	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50573008	79.0%
Common	13403354	21.0%

Most frequent Latin characters

Value	Count	Frequency (%)
t	8778342	17.4%
a	6073454	12.0%
S	4429118	8.8%
e	3371135	6.7%
r	3134014	6.2%
n	3036622	6.0%
o	2540444	5.0%
i	1855330	3.7%
l	1749711	3.5%
s	1493751	3.0%
h	1391593	2.8%
d	1154115	2.3%
c	884280	1.7%
B	859934	1.7%
A	796863	1.6%
y	723039	1.4%
k	674159	1.3%
v	630303	1.2%
T	620742	1.2%
M	614401	1.2%
P	543646	1.1%
F	453604	0.9%
m	447275	0.9%
w	438080	0.9%
u	435219	0.9%
Other values (25)	3443834	6.8%

Most frequent Common characters

Value	Count	Frequency (%)
	10770968	80.4%
1	416820	3.1%
(	366393	2.7%
)	366393	2.7%
2	357586	2.7%
4	303569	2.3%
5	175113	1.3%
7	136498	1.0%
3	115028	0.9%
0	106214	0.8%
9	88065	0.7%
6	78822	0.6%
8	77946	0.6%
/	23930	0.2%
'	13283	0.1%
&	6669	< 0.1%
-	57	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63976362	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	10770968	16.8%
t	8778342	13.7%
a	6073454	9.5%
S	4429118	6.9%
e	3371135	5.3%
r	3134014	4.9%
n	3036622	4.7%
o	2540444	4.0%
i	1855330	2.9%
l	1749711	2.7%
s	1493751	2.3%
h	1391593	2.2%
d	1154115	1.8%
c	884280	1.4%
B	859934	1.3%
A	796863	1.2%
y	723039	1.1%
k	674159	1.1%
v	630303	1.0%
T	620742	1.0%
M	614401	1.0%
P	543646	0.8%
F	453604	0.7%
m	447275	0.7%
w	438080	0.7%
Other values (42)	6511439	10.2%

start_station_latitude
Real number (ℝ_≥0)

SKEWED

Distinct count	74719
Unique (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.7650637139919
Minimum	0.0
Maximum	45.51
Zeros	12
Zeros (%)	< 0.1%
Memory size	19.1 MiB

Quantile statistics

Minimum	0
5-th percentile	37.3448821
Q1	37.7693053
median	37.780526
Q3	37.79539294
95-th percentile	37.866249
Maximum	45.51
Range	45.51
Interquartile range (IQR)	0.0260876373

Descriptive statistics

Standard deviation	0.13636983
Coefficient of variation (CV)	0.003611004898
Kurtosis	28171.78928
Mean	37.76506371
Median Absolute Deviation (MAD)	0.013604
Skewness	-103.0494041
Sum	94676372.72
Variance	0.01859673054

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
37.776619	45058	1.8%
37.77588	42962	1.7%
37.776598	40303	1.6%
37.795392	39016	1.6%
37.7766392	36576	1.5%
37.7896254	36081	1.4%
37.78637527	34253	1.4%
37.79413	32448	1.3%
37.789756	31341	1.3%
37.78389936	30581	1.2%
37.80477	28785	1.1%
37.780526	24424	1.0%
37.77874161	23093	0.9%
37.792251	22094	0.9%
37.7704074	21437	0.9%
37.771058	21116	0.8%
37.7880593	20818	0.8%
37.7810737	20551	0.8%
37.76704458	20015	0.8%
37.791464	19221	0.8%
37.7765126	18335	0.7%
37.8693603	17302	0.7%
37.788975	17158	0.7%
37.7644783	17100	0.7%
37.77143136	16127	0.6%
Other values (74694)	1830788	73.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	12	< 0.1%
36.16326117	1	< 0.1%
36.163307	1	< 0.1%
36.16331083	1	< 0.1%
36.163449	1	< 0.1%
36.16358	1	< 0.1%
37.26804867	1	< 0.1%
37.27951833	1	< 0.1%
37.2796155	1	< 0.1%
37.27962767	1	< 0.1%

Value	Count	Frequency (%)
45.51	4	< 0.1%
39.8925671	2	< 0.1%
37.89530017	1	< 0.1%
37.89218667	1	< 0.1%
37.89129667	1	< 0.1%
37.8882145	1	< 0.1%
37.88805183	1	< 0.1%
37.88579167	1	< 0.1%
37.88577283	1	< 0.1%
37.88575283	1	< 0.1%

start_station_longitude
Real number (ℝ)

SKEWED

Distinct count	75943
Unique (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-122.3499194884997
Minimum	-122.5142991667
Maximum	0.0
Zeros	12
Zeros (%)	< 0.1%
Memory size	19.1 MiB

Quantile statistics

Minimum	-122.5142992
5-th percentile	-122.4335369
Q1	-122.4130036
median	-122.3982847
Q3	-122.2914153
95-th percentile	-121.9086179
Maximum	0
Range	122.5142992
Interquartile range (IQR)	0.1215883

Descriptive statistics

Standard deviation	0.3089648379
Coefficient of variation (CV)	-0.002525255751
Kurtosis	119481.8018
Mean	-122.3499195
Median Absolute Deviation (MAD)	0.0165324263
Skewness	309.5870215
Sum	-306729168.2
Variance	0.09545927105

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-122.417385	45058	1.8%
-122.39317	42962	1.7%
-122.395282	40302	1.6%
-122.394203	39016	1.6%
-122.3955263	36576	1.5%
-122.400811	36081	1.4%
-122.4049044	34253	1.4%
-122.39443	32448	1.3%
-122.394643	31341	1.3%
-122.4084449	30581	1.2%
-122.403234	28785	1.1%
-122.390288	24424	1.0%
-122.3927408	23093	0.9%
-122.397086	22094	0.9%
-122.3911984	21437	0.9%
-122.402717	21116	0.8%
-122.3918648	20818	0.8%
-122.4117382	20551	0.8%
-122.3908335	20015	0.8%
-122.391034	19219	0.8%
-122.4113061	18335	0.7%
-122.2543374	17302	0.7%
-122.403452	17158	0.7%
-122.4025701	17100	0.7%
-122.4057868	16127	0.6%
Other values (75918)	1830791	73.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-122.5142992	1	< 0.1%
-122.513847	1	< 0.1%
-122.5138378	1	< 0.1%
-122.5138162	1	< 0.1%
-122.5137985	1	< 0.1%
-122.5137767	1	< 0.1%
-122.5131427	1	< 0.1%
-122.5119482	1	< 0.1%
-122.5117435	1	< 0.1%
-122.5117097	1	< 0.1%

Value	Count	Frequency (%)
0	12	< 0.1%
-73.57	4	< 0.1%
-75.17371416	2	< 0.1%
-86.77517717	1	< 0.1%
-86.77563417	1	< 0.1%
-86.7757685	1	< 0.1%
-86.77581167	1	< 0.1%
-86.77601767	1	< 0.1%
-121.8117485	1	< 0.1%
-121.8134252	1	< 0.1%

end_station_id
Real number (ℝ_≥0)

MISSING

Distinct count	436
Unique (%)	< 0.1%
Missing	82902
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%

Mean	142.70442406833766
Minimum	3.0
Maximum	498.0
Zeros	0
Zeros (%)	0.0%
Memory size	19.1 MiB

Quantile statistics

Minimum	3
5-th percentile	8
Q1	43
median	101
Q3	239
95-th percentile	373
Maximum	498
Range	495
Interquartile range (IQR)	196

Descriptive statistics

Standard deviation	121.4296491
Coefficient of variation (CV)	0.8509172009
Kurtosis	-0.4842603229
Mean	142.7044241
Median Absolute Deviation (MAD)	78
Skewness	0.8058184619
Sum	345927083
Variance	14745.15968

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
67	52146	2.1%
30	50943	2.0%
15	48180	1.9%
21	47886	1.9%
58	44284	1.8%
81	42231	1.7%
3	37466	1.5%
16	33319	1.3%
6	33286	1.3%
5	31540	1.3%
22	29459	1.2%
50	25677	1.0%
93	25046	1.0%
90	23342	0.9%
44	23208	0.9%
17	22223	0.9%
66	21713	0.9%
27	21621	0.9%
350	19984	0.8%
104	19925	0.8%
23	19736	0.8%
61	19002	0.8%
19	18111	0.7%
114	18054	0.7%
182	17093	0.7%
Other values (411)	1678606	67.0%
(Missing)	82902	3.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	37466	1.5%
4	7263	0.3%
5	31540	1.3%
6	33286	1.3%
7	9646	0.4%
8	10721	0.4%
9	10079	0.4%
10	11198	0.4%
11	12162	0.5%
12	3284	0.1%

Value	Count	Frequency (%)
498	10	< 0.1%
495	24	< 0.1%
494	11	< 0.1%
493	360	< 0.1%
492	33	< 0.1%
491	10	< 0.1%
490	58	< 0.1%
489	67	< 0.1%
488	12	< 0.1%
487	329	< 0.1%

end_station_name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	446
Unique (%)	< 0.1%
Missing	82350
Missing (%)	3.3%
Memory size	19.1 MiB

San Francisco Caltrain Station 2 (Townsend St at 4th St)	52146
San Francisco Caltrain (Townsend St at 4th St)	50943
San Francisco Ferry Building (Harry Bridges Plaza)	48180
Montgomery St BART Station (Market St at 2nd St)	47886
Market St at 10th St	44284
Other values (441)	2181194

Value	Count	Frequency (%)
San Francisco Caltrain Station 2 (Townsend St at 4th St)	52146	2.1%
San Francisco Caltrain (Townsend St at 4th St)	50943	2.0%
San Francisco Ferry Building (Harry Bridges Plaza)	48180	1.9%
Montgomery St BART Station (Market St at 2nd St)	47886	1.9%
Market St at 10th St	44284	1.8%
Berry St at 4th St	42231	1.7%
Powell St BART Station (Market St at 4th St)	37466	1.5%
Steuart St at Market St	33319	1.3%
The Embarcadero at Sansome St	33286	1.3%
Powell St BART Station (Market St at 5th St)	31540	1.3%
Howard St at Beale St	29459	1.2%
2nd St at Townsend St	25677	1.0%
4th St at Mission Bay Blvd S	25046	1.0%
Townsend St at 7th St	23342	0.9%
Civic Center/UN Plaza BART Station (Market St at McAllister St)	23208	0.9%
Embarcadero BART Station (Beale St at Market St)	22223	0.9%
3rd St at Townsend St	21713	0.9%
Beale St at Harrison St	21621	0.9%
8th St at Brannan St	19984	0.8%
4th St at 16th St	19925	0.8%
The Embarcadero at Steuart St	19736	0.8%
Howard St at 8th St	19002	0.8%
Post St at Kearny St	18111	0.7%
Rhode Island St at 17th St	18054	0.7%
19th Street BART Station	17093	0.7%
Other values (421)	1679158	67.0%
(Missing)	82350	3.3%

Length

Max length	63
Median length	22
Mean length	26.1590633
Min length	3

Overview of Unicode Properties

Unique unicode characters	67
Unique unicode categories (?)	8
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	11012180	16.8%
t	8929686	13.6%
a	6220131	9.5%
S	4536711	6.9%
e	3306264	5.0%
n	3273585	5.0%
r	3208579	4.9%
o	2603744	4.0%
i	1992641	3.0%
l	1735652	2.6%
s	1552276	2.4%
h	1425648	2.2%
d	1197318	1.8%
c	927313	1.4%
B	892946	1.4%
A	789425	1.2%
y	738928	1.1%
T	672517	1.0%
k	660464	1.0%
M	642164	1.0%
v	600912	0.9%
P	541199	0.8%
F	494156	0.8%
m	481648	0.7%
w	459319	0.7%
Other values (42)	6684921	10.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	40873107	62.3%
Space Separator	11012180	16.8%
Uppercase Letter	10889086	16.6%
Decimal Number	1923889	2.9%
Open Punctuation	418734	0.6%
Close Punctuation	418734	0.6%
Other Punctuation	44541	0.1%
Dash Punctuation	56	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
S	4536711	41.7%
B	892946	8.2%
A	789425	7.2%
T	672517	6.2%
M	642164	5.9%
P	541199	5.0%
F	494156	4.5%
C	420495	3.9%
R	344172	3.2%
H	311824	2.9%
E	182793	1.7%
V	146015	1.3%
D	141213	1.3%
W	131801	1.2%
G	131220	1.2%
N	99938	0.9%
K	84447	0.8%
J	82514	0.8%
L	79593	0.7%
U	65742	0.6%
O	52851	0.5%
I	33417	0.3%
Y	11891	0.1%
Q	42	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
t	8929686	21.8%
a	6220131	15.2%
e	3306264	8.1%
n	3273585	8.0%
r	3208579	7.9%
o	2603744	6.4%
i	1992641	4.9%
l	1735652	4.2%
s	1552276	3.8%
h	1425648	3.5%
d	1197318	2.9%
c	927313	2.3%
y	738928	1.8%
k	660464	1.6%
v	600912	1.5%
m	481648	1.2%
w	459319	1.1%
u	438243	1.1%
g	400857	1.0%
b	296426	0.7%
p	141434	0.3%
z	132335	0.3%
f	96627	0.2%
q	34958	0.1%
j	10721	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	11012180	100.0%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	418734	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	427957	22.2%
2	376825	19.6%
4	330311	17.2%
5	170819	8.9%
7	143214	7.4%
3	115785	6.0%
0	104264	5.4%
9	90111	4.7%
8	82573	4.3%
6	82030	4.3%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	418734	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	26492	59.5%
'	10510	23.6%
&	7539	16.9%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	56	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51762193	78.9%
Common	13818134	21.1%

Most frequent Latin characters

Value	Count	Frequency (%)
t	8929686	17.3%
a	6220131	12.0%
S	4536711	8.8%
e	3306264	6.4%
n	3273585	6.3%
r	3208579	6.2%
o	2603744	5.0%
i	1992641	3.8%
l	1735652	3.4%
s	1552276	3.0%
h	1425648	2.8%
d	1197318	2.3%
c	927313	1.8%
B	892946	1.7%
A	789425	1.5%
y	738928	1.4%
T	672517	1.3%
k	660464	1.3%
M	642164	1.2%
v	600912	1.2%
P	541199	1.0%
F	494156	1.0%
m	481648	0.9%
w	459319	0.9%
u	438243	0.8%
Other values (25)	3440724	6.6%

Most frequent Common characters

Value	Count	Frequency (%)
	11012180	79.7%
1	427957	3.1%
(	418734	3.0%
)	418734	3.0%
2	376825	2.7%
4	330311	2.4%
5	170819	1.2%
7	143214	1.0%
3	115785	0.8%
0	104264	0.8%
9	90111	0.7%
8	82573	0.6%
6	82030	0.6%
/	26492	0.2%
'	10510	0.1%
&	7539	0.1%
-	56	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65580327	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	11012180	16.8%
t	8929686	13.6%
a	6220131	9.5%
S	4536711	6.9%
e	3306264	5.0%
n	3273585	5.0%
r	3208579	4.9%
o	2603744	4.0%
i	1992641	3.0%
l	1735652	2.6%
s	1552276	2.4%
h	1425648	2.2%
d	1197318	1.8%
c	927313	1.4%
B	892946	1.4%
A	789425	1.2%
y	738928	1.1%
T	672517	1.0%
k	660464	1.0%
M	642164	1.0%
v	600912	0.9%
P	541199	0.8%
F	494156	0.8%
m	481648	0.7%
w	459319	0.7%
Other values (42)	6684921	10.2%

end_station_latitude
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct count	76905
Unique (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.76421902594531
Minimum	0.0
Maximum	45.51
Zeros	80
Zeros (%)	< 0.1%
Memory size	19.1 MiB

Quantile statistics

Minimum	0
5-th percentile	37.3448821
Q1	37.7700298
median	37.7807601
Q3	37.79587283
95-th percentile	37.8660431
Maximum	45.51
Range	45.51
Interquartile range (IQR)	0.0258430333

Descriptive statistics

Standard deviation	0.2392885015
Coefficient of variation (CV)	0.006336381572
Kurtosis	19795.20156
Mean	37.76421903
Median Absolute Deviation (MAD)	0.0137155203
Skewness	-125.689168
Sum	94674255.11
Variance	0.05725898695

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
37.7766392	52146	2.1%
37.776598	50943	2.0%
37.795392	48180	1.9%
37.7896254	47886	1.9%
37.776619	44284	1.8%
37.77588	42232	1.7%
37.78637527	37466	1.5%
37.79413	33319	1.3%
37.80477	33286	1.3%
37.78389936	31540	1.3%
37.789756	29459	1.2%
37.780526	25677	1.0%
37.7704074	25046	1.0%
37.771058	23342	0.9%
37.7810737	23208	0.9%
37.792251	22223	0.9%
37.77874161	21713	0.9%
37.7880593	21621	0.9%
37.77143136	19984	0.8%
37.76704458	19925	0.8%
37.791464	19736	0.8%
37.7765126	19002	0.8%
37.788975	18112	0.7%
37.7644783	18054	0.7%
37.870139	16405	0.7%
Other values (76880)	1762194	70.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	< 0.1%
36.16314	1	< 0.1%
36.16338533	1	< 0.1%
36.1634205	1	< 0.1%
36.16345967	1	< 0.1%
36.16358	1	< 0.1%
36.73953817	1	< 0.1%
37.22610033	1	< 0.1%
37.244987	1	< 0.1%
37.2464625	1	< 0.1%

Value	Count	Frequency (%)
45.51	4	< 0.1%
39.8925671	2	< 0.1%
37.91295533	1	< 0.1%
37.91285367	1	< 0.1%
37.90295133	1	< 0.1%
37.89987783	1	< 0.1%
37.8998715	1	< 0.1%
37.89986517	1	< 0.1%
37.89524017	1	< 0.1%
37.89217	1	< 0.1%

end_station_longitude
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct count	77995
Unique (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-122.34590784656719
Minimum	-122.5142868333
Maximum	0.0
Zeros	80
Zeros (%)	< 0.1%
Memory size	19.1 MiB

Quantile statistics

Minimum	-122.5142868
5-th percentile	-122.4310597
Q1	-122.4117258
median	-122.398113
Q3	-122.2933996
95-th percentile	-121.9086179
Maximum	0
Range	122.5142868
Interquartile range (IQR)	0.1183262276

Descriptive statistics

Standard deviation	0.708041743
Coefficient of variation (CV)	-0.005787212302
Kurtosis	28510.04618
Mean	-122.3459078
Median Absolute Deviation (MAD)	0.0136251877
Skewness	165.6630369
Sum	-306719111.1
Variance	0.5013231098

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-122.3955263	52146	2.1%
-122.395282	50943	2.0%
-122.394203	48180	1.9%
-122.400811	47886	1.9%
-122.417385	44284	1.8%
-122.39317	42231	1.7%
-122.4049044	37466	1.5%
-122.39443	33319	1.3%
-122.403234	33286	1.3%
-122.4084449	31540	1.3%
-122.394643	29459	1.2%
-122.390288	25677	1.0%
-122.3911984	25046	1.0%
-122.402717	23342	0.9%
-122.4117382	23208	0.9%
-122.397086	22223	0.9%
-122.3927408	21713	0.9%
-122.3918648	21621	0.9%
-122.4057868	19984	0.8%
-122.3908335	19925	0.8%
-122.391034	19736	0.8%
-122.4113061	19002	0.8%
-122.403452	18111	0.7%
-122.4025701	18054	0.7%
-122.268422	16405	0.7%
Other values (77970)	1762196	70.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-122.5142868	1	< 0.1%
-122.5138242	1	< 0.1%
-122.5138193	1	< 0.1%
-122.513818	1	< 0.1%
-122.5138032	1	< 0.1%
-122.5138008	1	< 0.1%
-122.5137905	1	< 0.1%
-122.5131595	1	< 0.1%
-122.5124662	1	< 0.1%
-122.5119483	1	< 0.1%

Value	Count	Frequency (%)
0	80	< 0.1%
-73.57	4	< 0.1%
-75.17371416	2	< 0.1%
-86.77517717	1	< 0.1%
-86.77572833	1	< 0.1%
-86.7757935	1	< 0.1%
-86.77580517	1	< 0.1%
-86.7758545	1	< 0.1%
-121.469453	1	< 0.1%
-121.7336153	1	< 0.1%

bike_id
Real number (ℝ_≥0)

Distinct count	11070
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27898.32716177174
Minimum	4
Maximum	999941
Zeros	0
Zeros (%)	0.0%
Memory size	19.1 MiB

Quantile statistics

Minimum	4
5-th percentile	399
Q1	1952
median	4420
Q3	9682
95-th percentile	13066
Maximum	999941
Range	999937
Interquartile range (IQR)	7730

Descriptive statistics

Standard deviation	114606.6512
Coefficient of variation (CV)	4.108011585
Kurtosis	32.60656269
Mean	27898.32716
Median Absolute Deviation (MAD)	2711
Skewness	5.589032711
Sum	6.994063192e+10
Variance	1.31346845e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3135	912	< 0.1%
3146	911	< 0.1%
3569	889	< 0.1%
3249	882	< 0.1%
1502	882	< 0.1%
3009	874	< 0.1%
1406	871	< 0.1%
2174	866	< 0.1%
2692	862	< 0.1%
2293	862	< 0.1%
1258	861	< 0.1%
27	855	< 0.1%
1566	850	< 0.1%
2119	848	< 0.1%
2497	848	< 0.1%
1396	844	< 0.1%
1044	840	< 0.1%
1368	840	< 0.1%
3147	838	< 0.1%
1667	837	< 0.1%
3589	835	< 0.1%
3379	832	< 0.1%
1886	830	< 0.1%
3491	830	< 0.1%
1821	828	< 0.1%
Other values (11045)	2485556	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	2	< 0.1%
11	211	< 0.1%
12	570	< 0.1%
13	645	< 0.1%
14	321	< 0.1%
15	103	< 0.1%
17	322	< 0.1%
18	377	< 0.1%
22	384	< 0.1%
24	212	< 0.1%

Value	Count	Frequency (%)
999941	15	< 0.1%
999937	4	< 0.1%
999422	35	< 0.1%
998430	36	< 0.1%
998086	25	< 0.1%
997397	84	< 0.1%
996963	30	< 0.1%
996564	48	< 0.1%
995091	62	< 0.1%
993240	7	< 0.1%

user_type
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.1 MiB

Subscriber	2021166
Customer	485817

Value	Count	Frequency (%)
Subscriber	2021166	80.6%
Customer	485817	19.4%

Length

Max length	10
Median length	10
Mean length	9.612428963
Min length	8

Overview of Unicode Properties

Unique unicode characters	12
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
r	4528149	18.8%
b	4042332	16.8%
u	2506983	10.4%
s	2506983	10.4%
e	2506983	10.4%
S	2021166	8.4%
c	2021166	8.4%
i	2021166	8.4%
C	485817	2.0%
t	485817	2.0%
o	485817	2.0%
m	485817	2.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	21591213	89.6%
Uppercase Letter	2506983	10.4%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
S	2021166	80.6%
C	485817	19.4%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
r	4528149	21.0%
b	4042332	18.7%
u	2506983	11.6%
s	2506983	11.6%
e	2506983	11.6%
c	2021166	9.4%
i	2021166	9.4%
t	485817	2.3%
o	485817	2.3%
m	485817	2.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24098196	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
r	4528149	18.8%
b	4042332	16.8%
u	2506983	10.4%
s	2506983	10.4%
e	2506983	10.4%
S	2021166	8.4%
c	2021166	8.4%
i	2021166	8.4%
C	485817	2.0%
t	485817	2.0%
o	485817	2.0%
m	485817	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24098196	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
r	4528149	18.8%
b	4042332	16.8%
u	2506983	10.4%
s	2506983	10.4%
e	2506983	10.4%
S	2021166	8.4%
c	2021166	8.4%
i	2021166	8.4%
C	485817	2.0%
t	485817	2.0%
o	485817	2.0%
m	485817	2.0%

bike_share_for_all_trip
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	243259
Missing (%)	9.7%
Memory size	19.1 MiB

No	2086152
Yes	177572
(Missing)	243259

Frequency Table

Value	Count	Frequency (%)
No	2086152	83.2%
Yes	177572	7.1%
(Missing)	243259	9.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	duration_sec	start_time	end_time	start_station_id	start_station_name	start_station_latitude	start_station_longitude	end_station_id	end_station_name	end_station_latitude	end_station_longitude	bike_id	user_type	bike_share_for_all_trip
0	60863	2019-09-30 11:48:02.7100	2019-10-01 04:42:25.8640	465.0	San Francisco Caltrain Station (King St at 4th St)	37.776329	-122.394438	465.0	San Francisco Caltrain Station (King St at 4th St)	37.776329	-122.394438	12904	Customer	No
1	36019	2019-09-30 16:16:32.3530	2019-10-01 02:16:51.9820	294.0	Pierce Ave at Market St	37.327581	-121.884559	443.0	3rd St at Keyes St	37.320866	-121.876279	163	Customer	No
2	5615	2019-09-30 23:12:25.9980	2019-10-01 00:46:01.9590	370.0	Jones St at Post St	37.787327	-122.413278	4.0	Cyril Magnin St at Ellis St	37.785881	-122.408915	10737	Customer	No
3	1482	2019-09-30 23:57:34.6630	2019-10-01 00:22:16.8490	109.0	17th St at Valencia St	37.763316	-122.421904	460.0	Terry Francois Blvd at Warriors Way	37.769095	-122.386333	10346	Customer	No
4	1272	2019-09-30 23:53:28.6530	2019-10-01 00:14:41.0740	95.0	Sanchez St at 15th St	37.766219	-122.431060	127.0	Valencia St at 21st St	37.756708	-122.421025	1349	Subscriber	No
5	8648	2019-09-30 21:43:51.0140	2019-10-01 00:07:59.8930	11.0	Davis St at Jackson St	37.797280	-122.398436	3.0	Powell St BART Station (Market St at 4th St)	37.786375	-122.404904	9806	Customer	No
6	644	2019-09-30 23:54:43.1040	2019-10-01 00:05:27.6560	15.0	San Francisco Ferry Building (Harry Bridges Plaza)	37.795392	-122.394203	91.0	Berry St at King St	37.771762	-122.398438	9963	Subscriber	No
7	459	2019-09-30 23:54:42.8650	2019-10-01 00:02:22.3630	321.0	5th St at Folsom	37.780146	-122.403071	77.0	11th St at Natoma St	37.773507	-122.416040	531	Subscriber	No
8	625	2019-09-30 23:49:31.7050	2019-09-30 23:59:56.9160	16.0	Steuart St at Market St	37.794130	-122.394430	80.0	Townsend St at 5th St	37.775235	-122.397437	10906	Subscriber	No
9	1177	2019-09-30 23:39:34.0880	2019-09-30 23:59:11.2090	433.0	Gennessee St at Monterey Blvd	37.731657	-122.451122	139.0	Garfield Square (25th St at Harrison St)	37.751017	-122.411901	11058	Customer	No

Last rows

	duration_sec	start_time	end_time	start_station_id	start_station_name	start_station_latitude	start_station_longitude	end_station_id	end_station_name	end_station_latitude	end_station_longitude	bike_id	user_type	bike_share_for_all_trip
2506973	122	2019-02-01 00:17:32.2580	2019-02-01 00:19:34.9380	119.0	18th St at Noe St	37.761047	-122.432642	120.0	Mission Dolores Park	37.761420	-122.426435	4326	Subscriber	No
2506974	249	2019-02-01 00:15:12.0670	2019-02-01 00:19:21.6990	256.0	Hearst Ave at Euclid Ave	37.875112	-122.260553	247.0	Fulton St at Bancroft Way	37.867789	-122.265896	4642	Subscriber	No
2506975	256	2019-02-01 00:12:50.5540	2019-02-01 00:17:07.3620	241.0	Ashby BART Station	37.852477	-122.270213	248.0	Telegraph Ave at Ashby Ave	37.855956	-122.259795	4845	Subscriber	Yes
2506976	111	2019-02-01 00:14:49.8740	2019-02-01 00:16:41.3010	324.0	Union Square (Powell St at Post St)	37.788300	-122.408531	19.0	Post St at Kearny St	37.788975	-122.403452	4832	Subscriber	No
2506977	706	2019-02-01 00:04:40.6160	2019-02-01 00:16:27.0800	138.0	Jersey St at Church St	37.750900	-122.427411	78.0	Folsom St at 9th St	37.773717	-122.411647	5017	Subscriber	No
2506978	480	2019-02-01 00:04:49.7240	2019-02-01 00:12:50.0340	27.0	Beale St at Harrison St	37.788059	-122.391865	324.0	Union Square (Powell St at Post St)	37.788300	-122.408531	4832	Subscriber	No
2506979	313	2019-02-01 00:05:34.7440	2019-02-01 00:10:48.5020	21.0	Montgomery St BART Station (Market St at 2nd St)	37.789625	-122.400811	66.0	3rd St at Townsend St	37.778742	-122.392741	4960	Subscriber	No
2506980	141	2019-02-01 00:06:05.5490	2019-02-01 00:08:27.2200	278.0	The Alameda at Bush St	37.331932	-121.904888	277.0	Morrison Ave at Julian St	37.333658	-121.908586	3824	Subscriber	Yes
2506981	139	2019-02-01 00:05:34.3600	2019-02-01 00:07:54.2870	220.0	San Pablo Ave at MLK Jr Way	37.811351	-122.273422	216.0	San Pablo Ave at 27th St	37.817827	-122.275698	5095	Subscriber	No
2506982	271	2019-02-01 00:00:20.6360	2019-02-01 00:04:52.0580	24.0	Spear St at Folsom St	37.789677	-122.390428	37.0	2nd St at Folsom St	37.785000	-122.395936	1057	Subscriber	No

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Dash Punctuation characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Dash Punctuation characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Open Punctuation characters

Most frequent Decimal Number characters

Most frequent Close Punctuation characters

Most frequent Other Punctuation characters

Most frequent Dash Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Open Punctuation characters

Most frequent Decimal Number characters

Most frequent Close Punctuation characters

Most frequent Other Punctuation characters

Most frequent Dash Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows